lines = open('primers_export.csv').readlines()

lines = [ l.replace('"','').replace("'",'').strip() for l in lines ]
columns = [ l.split('\t') for l in lines ]

names = [ l[0].strip() for l in columns ]
primers=[ l[1].strip() for l in columns ]

names = [ n[:-1] if n[-1]=='5' else n for n in names ]
primers = [ p.replace('-','').replace(' ', '') for p in primers ]

f = open('primers_cleaned.csv','w')
for n, p in zip( names, primers):
    f.write( '%s\t%s\n' % (n, p) )

f.close()
